class CreateBids < ActiveRecord::Migration
  def self.up
    create_table :bids do |t|
      # t.column :name, :string
      t.column :year,        :integer, :null => false
      t.column :territory,        :integer, :null => false
      t.column :area,        :float,  :null => false
      t.column :prop_ref,        :integer, :null => false
      t.column :address,  :string
      t.column :business_unit,  :string
      t.column :prop_dept_contact,  :string
      t.column :project_type,  :string
      t.column :business_case,  :string
      t.column :on_target,  :string
      t.column :cashflow_qtr,  :string
      t.column :cap_receipt,        :integer, :null => false
      t.column :cap_spend,        :integer, :null => false
      t.column :cap_retail_spend,        :integer, :null => false
      t.column :completed,  :string
      t.column :comments,  :text
    end
  end

  def self.down
    drop_table :bids
  end
end
